﻿CREATE TYPE [flcr].[FACILITY_UDT] AS  TABLE (
    [FACILITY_ID]         INT              NULL,
    [AUDIT_USER]          VARCHAR (100)    NULL,
    [AUDIT_DTTM]          DATETIME         NULL,
    [AUDIT_DTTM_TZ]       INT              NULL,
    [AUDIT_MOD_USER]      VARCHAR (100)    NULL,
    [AUDIT_MOD_DTTM]      DATETIME         NULL,
    [AUDIT_MOD_DTTM_TZ]   INT              NULL,
    [RLS_MASK]            VARBINARY (1)    NULL,
    [RLS_OWNER]           UNIQUEIDENTIFIER NULL,
    [BUILTIN]             BIT              NULL,
    [WRKFL_STATUS_ID]     INT              NULL,
    [ACTIVE_FLG]          BIT              NULL,
    [SORT_ORDER]          INT              NULL,
    [FACILITY_NAME]       VARCHAR (100)    NULL,
    [FACILITY_SNAME]      VARCHAR (50)     NULL,
    [FACILITY_DESC]       VARCHAR (MAX)    NULL,
    [FACILITY_TYPE]       INT              NULL,
    [AXIS_UTL_MEASURE_ID] INT              NULL,
    [X_AXIS]              INT              NULL,
    [Y_AXIS]              INT              NULL,
    [Z_AXIS]              INT              NULL,
    [TIMEZONE_TYPE]       INT              NULL,
    [ORG_ID]              INT              NULL,
    [PARENT_ID]           INT              NULL);

